oracle 审计

发表于 | 更新于 | 分类于

ORACLE审计

查看审计参数

1
select value from v$parameter where name='audit_trail';

停止审计create session，并审计create table，truncate table ，alter table等

1
2
noaudit connect;
audit table by access whenever successful;

审计对象

1
audit delete on table_name;

查看语句审计

1
select * from sys.dba_stmt_audit_opts;

查看对象审计

1
select * from dba_obj_audit_opts;

查看审计信息

1
2
3
select * from DBA_AUDIT_OBJECT;
select * from dba_audit_statement;
select * from DBA_AUDIT_TRAIL;